package com.jwtter.generator.db.sql;

import java.util.Date;

/**
 * select * from all_tab_columns ; 表字段属性
 * 
 * @date 2017年6月15日
 * @author jinwt
 */
public class AllTabColumns {
	String OWNER;// VARCHAR2(30) NOT NULL Owner of the table, view, or cluster
	String TABLE_NAME;// VARCHAR2(30) NOT NULL Name of the table, view, or cluster
	String COLUMN_NAME;// VARCHAR2(30) NOT NULL Column name
	String DATA_TYPE;// VARCHAR2(106) Datatype of the column
	String DATA_TYPE_MOD;// VARCHAR2(3) Datatype modifier of the column
	String DATA_TYPE_OWNER;// VARCHAR2(30) Owner of the datatype of the column
	int DATA_LENGTH;// NUMBER NOT NULL Length of the column (in bytes) 列的数据类型的字节长度
	int DATA_PRECISION;// NUMBER Decimal precision for NUMBER datatype; binary precision for FLOAT
						// datatype, null for all other datatypes 数字类型的实际长度*/
	int DATA_SCALE;// NUMBER Digits to right of decimal point in a number 小数点位数
	String NULLABLE;// VARCHAR2(1) Specifies whether a column allows NULLs. Value is N if there is a
					// NOT
					// NULL constraint on the column or if the column is part of a PRIMARY KEY. The
					// constraint should be in an ENABLE VALIDATE state.
	int COLUMN_ID;// NUMBER Sequence number of the column as created
	int DEFAULT_LENGTH;// NUMBER Length of default value for the column
	long DATA_DEFAULT;// LONG Default value for the column
	int NUM_DISTINCT;// NUMBER Number of distinct values in the columnFoot 1
	String LOW_VALUE;// RAW(32) Low value in the columnFootref 1
	String HIGH_VALUE;// RAW(32) High value in the columnFootref 1
	int DENSITY;// NUMBER Density of the columnFootref 1
	int NUM_NULLS;// NUMBER Number of nulls in the column
	int NUM_BUCKETS;// NUMBER Number of buckets in the histogram for the column
	// Note: The number of buckets in a histogram is specified in the SIZE parameter of the SQL
	// statement ANALYZE. However, the Oracle Database does not create a histogram with more buckets
	// than the number of rows in the sample. Also, if the sample contains any values that are very
	// repetitious, the Oracle Database creates the specified number of buckets, but the value
	// indicated by this column may be smaller because of an internal compression algorithm.

	Date LAST_ANALYZED;// DATE Date on which this column was most recently analyzed
	int SAMPLE_SIZE;// NUMBER Sample size used in analyzing this column
	String CHARACTER_SET_NAME;// VARCHAR2(44) Name of the character set: CHAR_CS or NCHAR_CS
	int CHAR_COL_DECL_LENGTH;// NUMBER Length
	String GLOBAL_STATS;// VARCHAR2(3) For partitioned tables, indicates whether column statistics
						// were
	// collected for the table as a whole (YES) or were estimated from statistics on
	// underlying partitions and subpartitions (NO)
	String USER_STATS;// VARCHAR2(3) Indicates whether statistics were entered directly by the user
						// (YES)
	// or not (NO)
	int AVG_COL_LEN;// NUMBER Average length of the column (in bytes)
	int CHAR_LENGTH;// NUMBER Displays the length of the column in characters. This value only
					// applies
	// to the following datatypes:
	// CHAR
	// VARCHAR2
	// NCHAR
	// NVARCHAR
	// CHAR_USED VARCHAR2(1) B | C. B indicates that the column uses BYTE length semantics. C
	// indicates that the column uses CHAR length semantics. NULL indicates the datatype is not any
	// of the following:
	// CHAR
	// VARCHAR2
	// NCHAR
	// NVARCHAR2
	String V80_FMT_IMAGE;// VARCHAR2(3) Indicates whether the column data is in release 8.0 image
							// format
	// (YES) or not (NO)
	String DATA_UPGRADED;// VARCHAR2(3) Indicates whether the column data has been upgraded to the
							// latest
	// type version format (YES) or not (NO)
	String HISTOGRAM;// VARCHAR2(15) Indicates existence/type of histogram:
	// NONE
	// FREQUENCY
	// HEIGHT BALANCED
	public String getOWNER() {
		return OWNER;
	}
	public void setOWNER(String oWNER) {
		OWNER = oWNER;
	}
	public String getTABLE_NAME() {
		return TABLE_NAME;
	}
	public void setTABLE_NAME(String tABLE_NAME) {
		TABLE_NAME = tABLE_NAME;
	}
	public String getCOLUMN_NAME() {
		return COLUMN_NAME;
	}
	public void setCOLUMN_NAME(String cOLUMN_NAME) {
		COLUMN_NAME = cOLUMN_NAME;
	}
	public String getDATA_TYPE() {
		return DATA_TYPE;
	}
	public void setDATA_TYPE(String dATA_TYPE) {
		DATA_TYPE = dATA_TYPE;
	}
	public String getDATA_TYPE_MOD() {
		return DATA_TYPE_MOD;
	}
	public void setDATA_TYPE_MOD(String dATA_TYPE_MOD) {
		DATA_TYPE_MOD = dATA_TYPE_MOD;
	}
	public String getDATA_TYPE_OWNER() {
		return DATA_TYPE_OWNER;
	}
	public void setDATA_TYPE_OWNER(String dATA_TYPE_OWNER) {
		DATA_TYPE_OWNER = dATA_TYPE_OWNER;
	}
	public int getDATA_LENGTH() {
		return DATA_LENGTH;
	}
	public void setDATA_LENGTH(int dATA_LENGTH) {
		DATA_LENGTH = dATA_LENGTH;
	}
	public int getDATA_PRECISION() {
		return DATA_PRECISION;
	}
	public void setDATA_PRECISION(int dATA_PRECISION) {
		DATA_PRECISION = dATA_PRECISION;
	}
	public int getDATA_SCALE() {
		return DATA_SCALE;
	}
	public void setDATA_SCALE(int dATA_SCALE) {
		DATA_SCALE = dATA_SCALE;
	}
	public String getNULLABLE() {
		return NULLABLE;
	}
	public void setNULLABLE(String nULLABLE) {
		NULLABLE = nULLABLE;
	}
	public int getCOLUMN_ID() {
		return COLUMN_ID;
	}
	public void setCOLUMN_ID(int cOLUMN_ID) {
		COLUMN_ID = cOLUMN_ID;
	}
	public int getDEFAULT_LENGTH() {
		return DEFAULT_LENGTH;
	}
	public void setDEFAULT_LENGTH(int dEFAULT_LENGTH) {
		DEFAULT_LENGTH = dEFAULT_LENGTH;
	}
	public long getDATA_DEFAULT() {
		return DATA_DEFAULT;
	}
	public void setDATA_DEFAULT(long dATA_DEFAULT) {
		DATA_DEFAULT = dATA_DEFAULT;
	}
	public int getNUM_DISTINCT() {
		return NUM_DISTINCT;
	}
	public void setNUM_DISTINCT(int nUM_DISTINCT) {
		NUM_DISTINCT = nUM_DISTINCT;
	}
	public String getLOW_VALUE() {
		return LOW_VALUE;
	}
	public void setLOW_VALUE(String lOW_VALUE) {
		LOW_VALUE = lOW_VALUE;
	}
	public String getHIGH_VALUE() {
		return HIGH_VALUE;
	}
	public void setHIGH_VALUE(String hIGH_VALUE) {
		HIGH_VALUE = hIGH_VALUE;
	}
	public int getDENSITY() {
		return DENSITY;
	}
	public void setDENSITY(int dENSITY) {
		DENSITY = dENSITY;
	}
	public int getNUM_NULLS() {
		return NUM_NULLS;
	}
	public void setNUM_NULLS(int nUM_NULLS) {
		NUM_NULLS = nUM_NULLS;
	}
	public int getNUM_BUCKETS() {
		return NUM_BUCKETS;
	}
	public void setNUM_BUCKETS(int nUM_BUCKETS) {
		NUM_BUCKETS = nUM_BUCKETS;
	}
	public Date getLAST_ANALYZED() {
		return LAST_ANALYZED;
	}
	public void setLAST_ANALYZED(Date lAST_ANALYZED) {
		LAST_ANALYZED = lAST_ANALYZED;
	}
	public int getSAMPLE_SIZE() {
		return SAMPLE_SIZE;
	}
	public void setSAMPLE_SIZE(int sAMPLE_SIZE) {
		SAMPLE_SIZE = sAMPLE_SIZE;
	}
	public String getCHARACTER_SET_NAME() {
		return CHARACTER_SET_NAME;
	}
	public void setCHARACTER_SET_NAME(String cHARACTER_SET_NAME) {
		CHARACTER_SET_NAME = cHARACTER_SET_NAME;
	}
	public int getCHAR_COL_DECL_LENGTH() {
		return CHAR_COL_DECL_LENGTH;
	}
	public void setCHAR_COL_DECL_LENGTH(int cHAR_COL_DECL_LENGTH) {
		CHAR_COL_DECL_LENGTH = cHAR_COL_DECL_LENGTH;
	}
	public String getGLOBAL_STATS() {
		return GLOBAL_STATS;
	}
	public void setGLOBAL_STATS(String gLOBAL_STATS) {
		GLOBAL_STATS = gLOBAL_STATS;
	}
	public String getUSER_STATS() {
		return USER_STATS;
	}
	public void setUSER_STATS(String uSER_STATS) {
		USER_STATS = uSER_STATS;
	}
	public int getAVG_COL_LEN() {
		return AVG_COL_LEN;
	}
	public void setAVG_COL_LEN(int aVG_COL_LEN) {
		AVG_COL_LEN = aVG_COL_LEN;
	}
	public int getCHAR_LENGTH() {
		return CHAR_LENGTH;
	}
	public void setCHAR_LENGTH(int cHAR_LENGTH) {
		CHAR_LENGTH = cHAR_LENGTH;
	}
	public String getV80_FMT_IMAGE() {
		return V80_FMT_IMAGE;
	}
	public void setV80_FMT_IMAGE(String v80_FMT_IMAGE) {
		V80_FMT_IMAGE = v80_FMT_IMAGE;
	}
	public String getDATA_UPGRADED() {
		return DATA_UPGRADED;
	}
	public void setDATA_UPGRADED(String dATA_UPGRADED) {
		DATA_UPGRADED = dATA_UPGRADED;
	}
	public String getHISTOGRAM() {
		return HISTOGRAM;
	}
	public void setHISTOGRAM(String hISTOGRAM) {
		HISTOGRAM = hISTOGRAM;
	}

}
